<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <lay-button type="normal" @click="search" size="sm">
          <i class="layui-icon layui-icon-refresh-three marginR5"></i>刷新
        </lay-button>
        <lay-button type="primary"  @click="navigateTo('./add')" size="sm">
          <i class="layui-icon layui-icon-add-one"></i>新增
        </lay-button>
        <download-excel class="hide-on-phone marginL15" :fields="exportExcel.fields" :data="exportExcelData" :type="exportExcel.type" :name="exportExcel.filename">
          <lay-button size="sm" type="danger">
            <i class="layui-icon layui-icon-export marginR5"></i>导出 Excel
          </lay-button>
        </download-excel>
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList" :where="where" page-data="replace"
        field="company_license_icon,company_license_credit_code,company_holder_name,company_name,company_location,company_register_capital,company_register_date,company_issuer,company_license_valid_date,company_approval_date,company_business_scope"
        :orderby="orderby" :getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
        v-slot:default="{data,pagination,loading,error,options}" :options="options" loadtime="manual" @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe  @selection-change="selectionChange">
          <uni-tr>
            <uni-th width="100" align="center"  sortable @sort-change="sortChange($event, 'company_license_icon')">营业执照</uni-th>
            <uni-th width="190" align="center" filter-type="search" @filter-change="filterChange($event, 'company_license_credit_code')" sortable @sort-change="sortChange($event, 'company_license_credit_code')">统一社会信用代码</uni-th>
            <uni-th width="140" align="center" filter-type="search" @filter-change="filterChange($event, 'company_holder_name')" sortable @sort-change="sortChange($event, 'company_holder_name')">法定代表人</uni-th>
            <uni-th width="260" align="center" filter-type="search" @filter-change="filterChange($event, 'company_name')" sortable @sort-change="sortChange($event, 'company_name')">名称</uni-th>
            <uni-th width="380" align="center" filter-type="search" @filter-change="filterChange($event, 'company_location')" sortable @sort-change="sortChange($event, 'company_location')">经营场所</uni-th>
            <uni-th width="130" align="center" filter-type="search" @filter-change="filterChange($event, 'company_register_capital')" sortable @sort-change="sortChange($event, 'company_register_capital')">注册资本</uni-th>
            <uni-th width="130" align="center" filter-type="timestamp" @filter-change="filterChange($event, 'company_register_date')" sortable @sort-change="sortChange($event, 'company_register_date')">成立日期</uni-th>
            <uni-th width="260" align="center" filter-type="search" @filter-change="filterChange($event, 'company_issuer')" sortable @sort-change="sortChange($event, 'company_issuer')">登记机关</uni-th>
            <uni-th width="170" align="center" filter-type="search" @filter-change="filterChange($event, 'company_license_valid_date')" sortable @sort-change="sortChange($event, 'company_license_valid_date')">营业执照有效期</uni-th>
            <uni-th width="130" align="center" filter-type="timestamp" @filter-change="filterChange($event, 'company_approval_date')" sortable @sort-change="sortChange($event, 'company_approval_date')">核准日期</uni-th>
            <uni-th width="500" align="center" filter-type="search" @filter-change="filterChange($event, 'company_business_scope')" sortable @sort-change="sortChange($event, 'company_business_scope')">经营范围</uni-th>
          </uni-tr>
          <uni-tr v-for="(item,index) in data" :key="index">
            <uni-td align="center">
              <template v-for="(file, j) in item.company_license_icon">
                <uni-file-picker :key="j" class="flexStyle" v-if="file.fileType == 'image'" :modelValue="file" :value="file" :file-mediatype="file.fileType" :imageStyles="imageStyles" readonly></uni-file-picker>
                <uni-link v-else :key="j+1" :href="file.url" :text="file.url"></uni-link>
              </template>
            </uni-td>
            <uni-td align="center">{{item.company_license_credit_code}}</uni-td>
            <uni-td align="center">{{item.company_holder_name}}</uni-td>
            <uni-td align="center">

              <lay-tooltip v-if="item.company_name.length>12" :content="item.company_name" :isDark="false">
                <div class="flexStyle">
                    {{item.company_name.substr(0,12)+' ...'}}
                  </div>
              </lay-tooltip>
              <div v-else>{{item.company_name}}</div>

            </uni-td>
            <uni-td align="center">

              <lay-tooltip v-if="item.company_location.length>20" :content="item.company_location" :isDark="false">
                <div class="flexStyle">
                    {{item.company_location.substr(0,20)+' ...'}}
                  </div>
              </lay-tooltip>
              <div v-else>{{item.company_location}}</div>

            </uni-td>
            <uni-td align="center">{{item.company_register_capital}}元</uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.company_register_date" format="yyyy-MM-dd"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
				
              <lay-tooltip v-if="item.company_issuer.length>12" :content="item.company_issuer" :isDark="false">
                <div class="flexStyle">
                    {{item.company_issuer.substr(0,12)+' ...'}}
                  </div>
              </lay-tooltip>
              <div v-else>{{item.company_issuer}}</div>

			</uni-td>
            <uni-td align="center">
              <div v-if="item.company_license_valid_date==='长期'">
                {{item.company_license_valid_date}}
              </div>
              <uni-dateformat v-else :threshold="[0, 0]" :date="(+item.company_license_valid_date)" format="yyyy-MM-dd"></uni-dateformat>
			</uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.company_approval_date" format="yyyy-MM-dd"></uni-dateformat>
            </uni-td>
            <uni-td align="center">

              <lay-tooltip v-if="item.company_business_scope.length>20" :content="item.company_business_scope" :isDark="false">
                <div class="flexStyle">
                    {{item.company_business_scope.substr(0,20)+' ...'}}
                  </div>
              </lay-tooltip>
              <div v-else>{{item.company_business_scope}}</div>
              
			</uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count" @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
  </view>
</template>

<script>
  import { enumConverter, filterToWhere } from '../../js_sdk/validator/compay-business-licence.js';
  import {store} from '@/uni_modules/uni-id-pages/common/store.js'

  const db = uniCloud.database()
  // 表查询配置
  const dbOrderBy = '' // 排序字段
  const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
  // 分页配置
  const pageSize = 20
  const pageCurrent = 1

  const orderByMapping = {
    "ascending": "asc",
    "descending": "desc"
  }

  export default {
    data() {
      return {
        collectionList: `compay-business-licence`,
        query: '',
        where: '',
        orderby: dbOrderBy,
        orderByFieldName: "",
        selectedIndexs: [],
        options: {
          pageSize,
          pageCurrent,
          filterData: {},
          ...enumConverter
        },
        imageStyles: {
          width: 64,
          height: 64
        },
        exportExcel: {
          "filename": "compay-business-licence.xls",
          "type": "xls",
          "fields": {
            "所属商户": "merchant_id",
            "营业执照": "company_license_icon",
            "统一社会信用代码": "company_license_credit_code",
            "法定代表人/经营者": "company_holder_name",
            "名称": "company_name",
            "经营场所/住所": "company_location",
            "注册资本": "company_register_capital",
            "注册/成立日期": "company_register_date",
            "发证/登记机关": "company_issuer",
            "营业执照有效期": "company_license_valid_date",
            "核准日期": "company_approval_date",
            "经营范围": "company_business_scope"
          }
        },
        exportExcelData: []
      }
    },
    onLoad() {
      this._filter = {}
    },
    mounted() {
      this.search();
    },
    methods: {
      getBaseWhere(params){
        if(store.userInfo&&store.userInfo.merchant_id){
            if(typeof params === 'string'){
              params+=`merchant_id=="${store.userInfo.merchant_id}"`
            }else{
              params.merchant_id=store.userInfo.merchant_id
            }
        }
        return params
      },

      onqueryload(data) {
        this.exportExcelData = data
      },
      getWhere() {
        const query = this.query.trim()
        if (!query) {
          return ''
        }
        const queryRe = new RegExp(query, 'i')
        return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
      },
      search() {
        const newWhere = this.getWhere()
        this.where = this.getBaseWhere(newWhere)
        this.$nextTick(() => {
          this.loadData()
        })
      },
      loadData(clear = true) {
        this.$refs.udb.loadData({
          clear
        })
      },
      onPageChanged(e) {
        this.selectedIndexs.length = 0
        this.$refs.table.clearSelection()
        this.$refs.udb.loadData({
          current: e.current
        })
      },
      navigateTo(url, clear) {
        // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
        uni.navigateTo({
          url,
          events: {
            refreshData: () => {
              this.loadData(clear)
            }
          }
        })
      },
      // 多选处理
      selectedItems() {
        var dataList = this.$refs.udb.dataList
        return this.selectedIndexs.map(i => dataList[i]._id)
      },
      // 批量删除
      delTable() {
        this.$refs.udb.remove(this.selectedItems(), {
          action:`no-comfig-remove`,
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      // 多选
      selectionChange(e) {
        this.selectedIndexs = e.detail.index
      },
      confirmDelete(id) {
        this.$refs.udb.remove(id, {
          action:`no-comfig-remove`,
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      sortChange(e, name) {
        this.orderByFieldName = name;
        if (e.order) {
          this.orderby = name + ' ' + orderByMapping[e.order]
        } else {
          this.orderby = ''
        }
        this.$refs.table.clearSelection()
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      },
      filterChange(e, name) {
        this._filter[name] = {
          type: e.filterType,
          value: e.filter
        }
        let newWhere = filterToWhere(this._filter, db.command)
        if (Object.keys(newWhere).length) {
          this.where = this.getBaseWhere(newWhere)
        } else {
          this.where = this.getBaseWhere('')
        }
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      }
    }
  }
</script>

<style>
</style>
